﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'ProvinciaGetListByPaisId')
	BEGIN
		DROP  Procedure  ProvinciaGetListByPaisId
	END
GO

CREATE PROCEDURE ProvinciaGetListByPaisId 	
	(	
		@paisId AS INT
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	SELECT ProvinciaId AS Id, Nombre 
	FROM Provincia
	WHERE paisId = @paisId  

	SET NOCOUNT OFF
END
GO

 
 
 
